package com.kws.merchant.mapper;

import com.kws.merchant.domain.OperationPollingDevice;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * 运维-巡检设备关联表(OperationPollingDevice)表数据库访问层
 *
 * @author yxy
 * @since 2024-10-28 11:32:39
 */

public interface OperationPollingDeviceMapper extends BaseMapper<OperationPollingDevice> {


    @Select("select o.*,t.`name` as deviceName from tb_operation_polling_device o  left join tb_device t on o.device_id=t.id where polling_id=${pollingId};")
    List<OperationPollingDevice> listByPolling(@Param("pollingId") Long pollingId);
}
